package com.xh.bussiness.practice.dao;

import com.xh.bussiness.practice.bean.request.PracticeStudentRequest;
import com.xh.bussiness.practice.model.PracticeStudent;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xh.core.bean.XhPage;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 学生作业表 Mapper 接口
 * </p>
 *
 * @author Pitt
 * @since 2021-01-26
 */
public interface PracticeStudentMapper extends BaseMapper<PracticeStudent> {

    void deleteByPracticeId(@Param("practiceId") String practiceId);

    XhPage<Map<String, Object>> queryPracticeStudentPage(XhPage page, @Param("bean") PracticeStudentRequest request);

    Double queryNormalQualified(@Param("practiceId") String practiceId);

    Double queryNormalProficiency(@Param("practiceId") String practiceId);

    List<PracticeStudent> queryPracticeStudentStatusCount(@Param("practiceId") String practiceId);
}
